{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["FilingGuide","Cover Pages 1-2","Cover Page 3","Report Pages 1-6","Report Page 5-A","SurchargeInformation","Data"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":2,"defined_names":8,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"FilingGuide","index":0,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Cover Pages 1-2","index":1,"n_rows":71,"n_cols":10,"rows_kept":71,"cut":false,"hidden":false,"merged":[[52,1,52,9],[12,4,12,8],[29,0,29,8],[31,0,31,8],[23,0,23,8],[14,1,14,2],[14,4,14,5],[17,1,17,2],[17,4,17,8],[20,1,20,2],[20,4,20,6],[26,0,26,8],[70,1,71,9],[33,5,33,6],[36,0,36,8],[41,0,41,9],[42,5,42,6],[46,0,46,9],[62,1,62,9],[64,1,64,9],[66,1,66,9],[68,1,68,9],[50,1,50,9],[54,1,54,9],[56,1,56,9],[58,1,58,9],[48,1,48,7],[60,1,60,7],[5,1,5,2],[5,4,5,5],[7,0,7,8],[9,1,9,7],[11,1,11,2],[11,4,11,8]]}
[]
[]
[null,null,null,null,null,null,null,null,null,"NARUC Class A or B"]
[null,null,null,null,null,null,null,null,null,"Privately Owned"]
[]
[null,"Docket No.:",null,null,"20-01003"]
[]
["ANNUAL REPORT"]
[]
[null,"OF"]
[]
[null,"Company Name:"]
[null,null,null,null,"(Legal Name of Utility)"]
[]
[null,"CPC Number(s):"]
[]
[]
[null,"Principal Office Address:"]
[]
[]
[null,"For the Period Ending:",null,null,"   December 31,",null,null,2019]
[]
[]
["WATER UTILITY"]
[]
[]
["TO THE"]
[]
[]
["PUBLIC UTILITIES COMMISSION"]
[]
["OF NEVADA"]
[]
[null,null,null,null,"Date of filing:"]
[]
[]
[{"$f":"CONCATENATE(\"Due by May 15, \",H21+1)","v":"Due by May 15, 2020"}]
[]
[null,null,null,null,"Check one:"]
[null,null,null,null,null,"Original Submission"]
[null,null,null,null,null,"Corrected Submission*"]
["* If the original filing is being amended or corrected, the entire report must be resubmitted."]
[null,null,null,null,"Corrected Filing Date:"]
[]
[]
[]
["GENERAL GUIDELINES FOR REPORTING"]
[]
["1.","This form is formatted using Microsoft Excel to allow for electronic preparation.   "]
[]
[2,"In the data areas on the following pages, please input the requested information in the gray highlighted areas.  The spreadsheet has been programmed to perform all the necessary calculations.  Non-highlighted areas are locked and cannot be accessed by the user."]
[]
[3,"Enter whole dollar amounts only.  Round cents up or down to the nearest whole dollar."]
[]
[4,"If the amount to be input into a normally positive data field is negative, then precede the amount with a negative sign (-)."]
[]
[5,"If the amount to be input is zero, then input a zero; Excel will display a hyphen in the cell.  Do not input a hyphen."]
[]
[6,"The annual report should be fully completed.  References to returns of former years or to other reports should not take the place of required entries except as specifically instructed by the PUCN."]
[]
[7,"Where information called for is not provided, explain the reason for its omission. "]
[]
[8,"If it is necessary or desirable to show additional statements or schedules for the purpose of further explanation, they should be made on standard letter-size paper.  Each additional supporting schedule should contain the page and line reference to the PUCN form so that PUCN staff will be able to follow the preparer's intentions."]
[]
[9,"Wherever schedules call for comparisons to figures of a previous year, the figures reported must be based upon those shown on this company's annual report from the previous year or an appropriate explanation given as to why different figures were used."]
[null,"      "]
[10,"The Nevada Administrative Code 704.628(6) requires that the books and records maintained by the utility must comply with the systems of accounts established for water/wastewater utilities prepared by the National Association of Regulatory Commissioners (NARUC).  The account numbers listed in the accompanying annual report are NARUC account numbers.  If the company uses a different account numbering system, please attach an explanation along with a cross-reference from the company's account numbers to the NARUC account numbers."]
[null,"      "]
[11,"If the utility collects and maintains a Commission-approved surcharge to fund system improvements, complete the supplemental surcharge information schedules located at the end of this report.  Remember to include a copy of the year-end bank statement for the surcharge account as requested on the form."]
[]
[12,"When printing this form, print each tab separately for correct pagination.  Do NOT print the entire workbook."]

{"sheet":"Cover Page 3","index":2,"n_rows":39,"n_cols":14,"rows_kept":39,"cut":false,"hidden":false,"merged":[[22,10,22,11],[23,10,23,11],[24,10,24,11],[25,10,25,11],[38,1,38,11],[25,3,25,8],[27,7,27,11],[30,2,30,8],[31,2,31,8],[32,2,32,8],[33,2,33,8],[34,2,34,8],[35,2,35,8],[36,2,36,8],[39,1,42,11],[11,2,11,7],[0,0,0,11],[2,0,2,11],[3,0,3,11],[4,0,4,11],[10,2,10,10],[8,2,8,10],[29,1,29,11],[13,4,13,6],[22,3,22,8],[18,2,18,8],[23,3,23,8],[24,3,24,8],[15,7,15,8],[19,4,19,8]]}
["PUBLIC UTILITIES COMMISSION OF NEVADA"]
[]
["WATER UTILITY ANNUAL REPORT"]
["Class A or B"]
["(Annual Revenues of more than $200,000)"]
[]
[1,{"$f":"CONCATENATE(\"For the Period Ending:    December 31, \",'Cover Pages 1-2'!H21)","v":"For the Period Ending:    December 31, 2019"},null,null,null,null,null,null,null,null,null,null,null,2006]
[]
[2,{"$f":"CONCATENATE(\"Report of:   \",'Cover Pages 1-2'!E12)","v":"Report of:   "}]
[]
[3,"Address:"]
[null,"     City:  ",null,null,null,null,null,null,"State:",null,"Zip Code:"]
[]
[4,"Telephone number:"]
[]
[5,"Date of original organization of utility:"]
[]
[6,"Person to whom correspondence should be addressed concerning this report:"]
[null,"      Name:"]
[null,"      Telephone No:"]
[]
[7,"Utility officers:"]
[null,"      President:",null,null,null,null,null,null,null,"Telephone No."]
[null,"      Vice-Pres:",null,null,null,null,null,null,null,"Telephone No."]
[null,"      Treasurer:",null,null,null,null,null,null,null,"Telephone No."]
[null,"      Secretary:",null,null,null,null,null,null,null,"Telephone No."]
[]
[8,"What public services are rendered?"]
[]
[9,"If a corporation - Provide the name and percentage of each person owning or holding directly or indirectly five (5) percent or more of the voting securities of this company:"]
[null,"      Name:",null,null,null,null,null,null,null,"Percent:  "]
[null,"      Name:",null,null,null,null,null,null,null,"Percent:  "]
[null,"      Name:",null,null,null,null,null,null,null,"Percent:  "]
[null,"      Name:",null,null,null,null,null,null,null,"Percent:  "]
[null,"      Name:",null,null,null,null,null,null,null,"Percent:  "]
[null,"      Name:",null,null,null,null,null,null,null,"Percent:  "]
[null,"      Name:",null,null,null,null,null,null,null,"Percent:  "]
[]
[10,"Give a brief description of major transactions which have occurred during the year which will have a material effect on operations, such as rate changes or changes in plant or operating practices.  Provide any additional information or other explanations that are needed in order for the reader to understand what is in the report, attaching additional pages if necessary:"]

{"sheet":"Report Pages 1-6","index":3,"n_rows":370,"n_cols":8,"rows_kept":370,"cut":false,"hidden":false,"merged":[[316,0,316,6],[372,1,372,2],[341,3,341,7],[343,3,343,7],[344,3,344,7],[345,3,345,7],[348,3,348,7],[354,1,354,2],[369,0,369,1],[369,4,369,5],[363,1,363,2],[340,3,340,7],[329,1,329,5],[319,2,319,4],[324,1,324,7],[320,2,320,4],[2,0,2,5],[185,0,185,5],[186,0,186,5],[62,0,62,5],[122,0,122,5],[123,0,123,5],[59,0,59,1],[59,4,59,5],[120,0,120,1],[120,4,120,5],[183,0,183,1],[183,4,183,5],[321,1,321,4],[331,1,331,7],[339,3,339,7],[322,1,322,4],[330,1,330,5],[333,1,333,5],[335,1,335,5],[336,1,336,5],[326,1,326,5],[327,1,327,5],[328,1,328,5],[325,1,325,5],[247,0,247,1],[247,4,247,5],[312,0,312,1],[312,4,312,5],[253,0,254,0],[252,0,252,5],[267,0,267,5],[276,0,276,5],[250,0,250,5]]}
[{"$f":"CONCATENATE(\"Annual Report of:    \",'Cover Pages 1-2'!E12)","v":"Annual Report of:    "},null,null,null,null,{"$f":"CONCATENATE(\"For the Period Ending:    December 31, \",'Cover Pages 1-2'!H21)","v":"For the Period Ending:    December 31, 2019"}]
[]
["WATER OPERATING REVENUES"]
[null,"(a)",null,"(b)","(c) ","(d)"]
["Line  No.","Descriptions ","NARUC Water Account Number","Dollar         Amount","Total                  Year-End Customers","Gallons of Water Sold Metered & Unmetered *"]
[null,"OPERATING REVENUES ",null,null,null,"(in Thousands)",null,"         (Decrease)"]
[null,"REVENUE FROM WATER SALES:  ",400]
[1,"Unmetered Water Revenues"]
[{"$f":"1+A8","v":2},"             Residential Customers",460.1,0,0,0]
[{"$f":"1+A9","v":3},"             Commercial Customers",460.2,0,0,0]
[4,"             Industrial Customers",460.3,0,0,0]
[5,"             Public Authorities",460.4,0,0,0]
[6,"             Multiple Family Dwellings",460.5,0,0,0]
[7,"             Other **",460.6,0,0,0]
[8,"                  Total Unmetered Sales",null,{"$f":"SUM(D9:D14)","v":0},{"$f":"SUM(E9:E14)","v":0},{"$f":"SUM(F9:F14)","v":0}]
[9]
[10,"Metered Water Revenues:"]
[11,"              Residential Customers",461.1,0,0,0]
[12,"              Commercial Customers",461.2,0,0,0]
[13,"              Industrial Customers",461.3,0,0,0]
[14,"              Public Authorities",461.4,0,0,0]
[15,"              Multiple Family Dwellings",461.5,0,0,0]
[16,"                   Total Metered Sales",null,{"$f":"SUM(D18:D22)","v":0},{"$f":"SUM(E18:E22)","v":0},{"$f":"SUM(F18:F22)","v":0}]
[17]
[18,"Private Fire-Protection Service ",462.1,0,0,0]
[19,"Public Fire-Protection Service ",462.2,0,0,0]
[20,"Other Sales to Public Authorities ",464,0,0,0]
[21,"Sales to Irrigation Customers ",465,0,0,0]
[22,"Sales for Resale ",466,0,0,0]
[23,"Interdepartmental Sales ",467,0,0,0]
[24,"                    Total Sales of Water         ",null,{"$f":"SUM(D25:D30)+D15+D23","v":0},{"$f":"SUM(E25:E30)+E15+E23","v":0},{"$f":"SUM(F25:F30)+F15+F23","v":0}]
[25,"         * When customer meters record in cubic feet, multiply by 7.45 to obtain number of gallons."]
[26]
[27,"OTHER WATER REVENUES:"]
[28,"Guaranteed Revenues",469,0]
[29,"Forfeited Discounts",470,0]
[30,"Miscellaneous Service Revenues",471,0]
[31,"Rents from Water Property",472,0]
[32,"Interdepartmental Rents",473,0]
[33,"Other Water Revenues **",474,0]
[34,"                      Total Other Water Revenues",null,{"$f":"SUM(D35:D40)","v":0}]
[35]
[36,"           Total Operating Revenues   ",400,{"$f":"+D31+D41","v":0}]
[null,"** If over $10,000, attach detailed supporting schedule."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Docket No. 20-01003\nWater - Class A or B",null,"Page 4 of 11",null,"Revised January 2020"]
[{"$f":"CONCATENATE(\"Annual Report of:    \",'Cover Pages 1-2'!E12)","v":"Annual Report of:    "},null,null,null,null,{"$f":"CONCATENATE(\"For the Period Ending:    December 31, \",'Cover Pages 1-2'!H21)","v":"For the Period Ending:    December 31, 2019"}]
[]
["INCOME AND RETAINED EARNINGS STATEMENT"]
[null,"(a)",null,"(b)","(c) ","(d)"]
["Line  No.","Descriptions","NARUC Water Account Number","This Year                    $","Last Year                   $","Increase or (Decrease)"]
[null,"UTILITY OPERATING INCOME"]
[1,"Operating Revenues                 (from Page 4, Line 36)",400,{"$f":"+D43","v":0},0,{"$f":"+D67-E67","v":0}]
[{"$f":"1+A67","v":2}]
[{"$f":"1+A68","v":3},"Operating Expense                    (from Page 5-A, Line 29)",401,{"$f":"+'Report Page 5-A'!I35","v":0},0,{"$f":"+D69-E69","v":0}]
["4a","Depreciation Expense               (to Page 6, Line 51, Col. (c))",403,0,0,{"$f":"+D70-E70","v":0}]
["4b","CIAC Amort. Expense - CR. *  (to Page 8, Line 27, Col. (c))",403,0,0,0]
[5,"Amortization of Utility Plant Adjustments",406,0,0,0]
[6,"Amortization Expense - Other **",407,0,0,0]
[7,"Taxes other than Income Taxes",408,0,0,0]
[8,"Federal Income Tax ",409,0,0,0]
[9,"Provision for Deferred Income Taxes - DR.",410,0,0,0]
[10,"Provision for Deferred Income Taxes - CR. *",411,0,0,0]
[11,"Investment Tax Credits - CR. *",412,0,0,0]
[12,"Income from Utility Plant Leased to Others",413,0,0,0]
[13,"(Gains *) Losses from Disposition of Utility Property",414,0,0,0]
[14,"               Total Operating Expenses   ",null,{"$f":"SUM(D69:D80)","v":0},{"$f":"SUM(E69:E80)","v":0},{"$f":"SUM(F69:F80)","v":0}]
[15]
[16,"Net Operating Income                ( Line 1 - Line 14)",null,{"$f":"+D67-D81","v":0},{"$f":"+E67-E81","v":0},{"$f":"+F67-F81","v":0}]
[17]
[18,"OTHER INCOME and DEDUCTIONS"]
[19,"Revenues from Merchandising, Jobbing & Contract",415,0,0,{"$f":"+D86-E86","v":0}]
[20,"Less:  Costs of Merchandising, Jobbing & Contract  *",416,0,0,0,{"$f":"SUM(G81:G86)+G72+G79","v":0},{"$f":"SUM(H81:H86)+H72+H79","v":0}]
[21,"Interest and Dividend Income",419,0,0,0]
[22,"Allowance for Funds Used During Construction",420,0,0,0]
[23,"Non-Utility Income",421,0,0,0]
[24,"Less:  Miscellaneous Non-Utility Expenses  * and **",426,0,0,0]
[25,"Taxes Applicable to Other Income & Deductions","408.2-412.3",0,0,{"$f":"+D92-E92","v":0}]
[26,"             Total Other Income & Deductions",null,{"$f":"SUM(D86:D92)","v":0},{"$f":"SUM(E86:E92)","v":0},{"$f":"SUM(F86:F92)","v":0}]
[27]
[28," INTEREST EXPENSES"]
[29,"Interest Expense",427,0,0,{"$f":"+D96-E96","v":0},{"$f":"SUM(G87:G95)","v":0},{"$f":"SUM(H87:H95)","v":0}]
[30,"Amort. of Debt Discount & Expense",428,0,0,{"$f":"+D97-E97","v":0}]
[31,"Amort. of Premium on Debt - CR. *",429,0,0,{"$f":"+D98-E98","v":0}]
[32,"               Total Interest Expenses",null,{"$f":"SUM(D96:D98)","v":0},{"$f":"SUM(E96:E98)","v":0},{"$f":"SUM(F96:F98)","v":0}]
[33]
[34,"EXTRAORDINARY ITEMS"]
[35,"Extraordinary Income",433,0,0,{"$f":"+D102-E102","v":0}]
[36,"Less:  Extraordinary Deductions  *",434,0,0,{"$f":"+D103-E103","v":0}]
[37,"Income Taxes on Extraordinary Items",409.3,0,0,{"$f":"+D104-E104","v":0}]
[38,"               Total Extraordinary Items",null,{"$f":"SUM(D102:D104)","v":0},{"$f":"SUM(E102:E104)","v":0},{"$f":"SUM(F102:F104)","v":0}]
[39]
[40,"Net Income                                                   (to Line 45)",null,{"$f":"+D83+D93-D99+D105","v":0},{"$f":"+E83+E93-E99+E105","v":0},{"$f":"+F83+F93-F99+F105","v":0}]
[41]
[42]
[43,"Retained Earnings   (Corporations ONLY)",215]
[44,"Retained Earnings (beginning)       (from \"Last Year\" col.)",null,{"$f":"+E118","v":0},0,{"$f":"+D111-E111","v":0}]
[45,"Balance Transferred from Net Income          (from Line 40)",435,{"$f":"+D107","v":0},{"$f":"+E107","v":0},0]
[46,"Appropriations of Retained Earnings",436,0,0,0]
[47,"Dividends Declared - Preferred Stock *",437,0,0,0]
[48,"Dividends Declared - Common Stock *",438,0,0,0]
[49,"Adjustments to Retained Earnings **",439,0,0,0]
[50]
[51,"Retained Earnings (ending)                    (to Page 7, Line 7)",null,{"$f":"SUM(D111:D116)","v":0},{"$f":"SUM(E111:E116)","v":0},{"$f":"SUM(F111:F116)","v":0}]
[null,"* Amount should be entered as NEGATIVE."]
[null,"** If over $10,000, attach detailed supporting schedule."]
["Docket No. 20-01003\nWater - Class A or B",null,"Page 5 of 11",null,"Revised January 2020"]
[{"$f":"CONCATENATE(\"Annual Report of:    \",'Cover Pages 1-2'!E12)","v":"Annual Report of:    "},null,null,null,null,{"$f":"CONCATENATE(\"For the Period Ending:    December 31, \",'Cover Pages 1-2'!H21)","v":"For the Period Ending:    December 31, 2019"}]
["BALANCE SHEET"]
["(Assets and Other Debits)"]
[null,"(a)",null,"(b)","(c)","(d)"]
["Line  No.","Descriptions","NARUC Water Account Number","This Year                    $","Last Year                   $","Increase or (Decrease)"]
[null,"UTILITY PLANT"]
[1,"Utility Plant                                (from Lines 53 & 49, Col. (b))",101,{"$f":"+D182","v":0},{"$f":"+D178","v":0},{"$f":"+D128-E128","v":0}]
[{"$f":"1+A128","v":2},"Less:  Accum.  Depr. & Amort.  (from Lines 53 & 49, Col. (c))","108, 110",{"$f":"-E182","v":0},{"$f":"-E178","v":0},{"$f":"+D129-E129","v":0}]
[{"$f":"1+A129","v":3},"          Net Utility Plant",null,{"$f":"SUM(D128:D129)","v":0},{"$f":"SUM(E128:E129)","v":0},{"$f":"SUM(F128:F129)","v":0}]
[4,"Utility Plant Leased to Others",102,0,0,{"$f":"+D131-E131","v":0}]
[5,"Property Held for Future Use",103,0,0,0]
[6,"Utility Plant Purchased or Sold",104,0,0,0]
[7,"Construction Work in Progress",105106,0,0,0]
[8,"Utility Plant Acquisition Adjustments",114,0,0,0]
[9,"Less:  Accum. Amort. Of Utility Plt. Acquisition Adj.  *",115,0,0,0]
[10,"          Total Utility Plant",null,{"$f":"SUM(D130:D136)","v":0},{"$f":"SUM(E130:E136)","v":0},{"$f":"SUM(F130:F136)","v":0}]
[11]
[12,"OTHER PROPERTY AND INVESTMENTS"]
[13,"Non-Utility Property",121,0,0,{"$f":"+D140-E140","v":0}]
[14,"Less:  Accum. Depreciation & Amortization  *",122,0,0,{"$f":"+D141-E141","v":0}]
[15,"          Net Non-Utility Property",null,{"$f":"SUM(D140:D141)","v":0},{"$f":"SUM(E140:E141)","v":0},{"$f":"SUM(F140:F141)","v":0}]
[16,"Investments in Associated Companies",123,0,0,{"$f":"+D143-E143","v":0}]
[17,"Utility Investments",124,0,0,{"$f":"+D144-E144","v":0}]
[18,"Other Investments **",125,0,0,{"$f":"+D145-E145","v":0}]
[19,"Sinking/Special Funds",126127,0,0,{"$f":"+D146-E146","v":0}]
[20,"          Total Other Property and Investments",null,{"$f":"SUM(D142:D146)","v":0},{"$f":"SUM(E142:E146)","v":0},{"$f":"SUM(F142:F146)","v":0}]
[21]
[22,"CURRENT AND ACCRUED ASSETS"]
[23,"Cash ",131,0,0,{"$f":"+D150-E150","v":0}]
[24,"Special Deposits",132133,0,0,0]
[25,"Working Funds",134,0,0,0]
[26,"Temporary Cash Investments",135,0,0,0]
[27,"Customer Accounts Receivable ",141,0,0,0]
[28,"Other Accounts Receivable",142,0,0,0]
[29,"Accum. Provision for Uncollectible Accounts - CR. *",143,0,0,0]
[30,"Notes Receivable",144,0,0,0]
[31,"Accounts Receivable from Associated Companies",145,0,0,0]
[32,"Notes Receivable from Associated Companies",146,0,0,0]
[33,"Plant Material and Supplies","151 to 161",0,0,0]
[34,"Prepayments",162,0,0,0]
[35,"Other Receivables **","171 to 173",0,0,0]
[36,"Miscellaneous Current and Accrued Assets **",174,0,0,0]
[37,"          Total Current & Accrued Assets",null,{"$f":"SUM(D150:D163)","v":0},{"$f":"SUM(E150:E163)","v":0},{"$f":"SUM(F150:F163)","v":0}]
[38]
[39,"DEFERRED DEBITS"]
[40,"Unamortized Debt Discount and Expense",181,0,0,{"$f":"+D167-E167","v":0}]
[41,"Extraordinary Property Losses",182,0,0,{"$f":"+D168-E168","v":0}]
[42,"Deferred Debits/Charges","183 to 187",0,0,{"$f":"+D169-E169","v":0}]
[43,"Accumulated Deferred Income Taxes",190,0,0,{"$f":"+D170-E170","v":0}]
[44,"           Total Deferred Debit",null,{"$f":"SUM(D167:D170)","v":0},{"$f":"SUM(E167:E170)","v":0},{"$f":"SUM(F167:F170)","v":0}]
[45]
[46,"        Total Assets & Other Debits          (to Page 8, Line 8)",null,{"$f":"+D137+D147+D164+D171","v":0},{"$f":"+E137+E147+E164+E171","v":0},{"$f":"+F137+F147+F164+F171","v":0}]
[]
[null,"(a)",null,"(b)","(c)","(d)"]
[{"$f":"A173+1","v":47},"WATER UTILITY PLANT",null,"Total Utility Plant","Accum. Deprec.","Net"]
[48,"PLANT",null,"(Acct. 101)","(Acct. 108)","Utility Plant"]
[49,"Balance Beginning of Year",null,null,0,{"$f":"+D178-E178","v":0}]
[50,"Additions:                                              (Plant added during the year)",null,null,null,{"$f":"+D179","v":0}]
[51,"Current Yr's Dep. on Plant                    (from Page 5, Line 4a)",null,null,{"$f":"+D70","v":0},{"$f":"-E180","v":0}]
[52,"Retirements / Deletions: - CR. *           (Plant removed during the year)",null,0,0,{"$f":"+D181-E181","v":0}]
[53,"Balance End of Current Year",null,{"$f":"+D178+D179+D181","v":0},{"$f":"+E178+E180+E181","v":0},{"$f":"+D182-E182","v":0}]
[null,"* Amount should be entered as NEGATIVE.","** If over $10,000, attach detailed supporting schedule."]
["Docket No. 20-01003\nWater - Class A or B",null,"Page 6 of 11",null,"Revised January 2020"]
[{"$f":"CONCATENATE(\"Annual Report of:    \",'Cover Pages 1-2'!E12)","v":"Annual Report of:    "},null,null,null,null,{"$f":"CONCATENATE(\"For the Period Ending:    December 31, \",'Cover Pages 1-2'!H21)","v":"For the Period Ending:    December 31, 2019"}]
["BALANCE SHEET"]
["(Liabilities and Other Credits)"]
[null,"(a)",null,"(b)","(c)","(d)"]
["Line  No.","Descriptions","NARUC Water Account Number","This Year                    $","Last Year                   $","Increase or (Decrease)"]
[null,"EQUITY CAPITAL"]
[1,"Common Stock Issued ","201 to 203",0,0,{"$f":"+D191-E191","v":0}]
[{"$f":"1+A191","v":2},"Preferred Stock Issued","204 to 206",0,0,0]
[{"$f":"1+A192","v":3},"Other Paid-In Capital ","209 to 211",0,0,0]
[4,"Premium/Discount on Capital Stock","207, 212",0,0,0]
[5,"Capital Stock Expense",213,0,0,0]
[6,"Appropriated Retained Earnings",214,0,0,0]
[7,"Unappropriated Retained Earnings (from Page 5, Line 51)",215,{"$f":"+D118","v":0},{"$f":"+E118","v":0},0]
[8,"Reacquired Capital Stock",216,0,0,0]
[9,"Proprietary Capital   (Proprietorships/Partnerships ONLY)",218,0,0,0]
[10,"        Total Equity Capital",null,{"$f":"SUM(D191:D199)","v":0},{"$f":"SUM(E191:E199)","v":0},{"$f":"SUM(F191:F199)","v":0}]
[11]
[12,"LONG TERM DEBT"]
[13,"Bonds",221222,0,0,{"$f":"+D203-E203","v":0}]
[14,"Advances from Associated Companies",223,0,0,{"$f":"+D204-E204","v":0}]
[15,"Other Long-Term Debt ",224,0,0,{"$f":"+D205-E205","v":0}]
[16,"         Total Long-Term Debt ",null,{"$f":"SUM(D203:D205)","v":0},{"$f":"SUM(E203:E205)","v":0},{"$f":"SUM(F203:F205)","v":0}]
[17]
[18,"CURRENT AND ACCRUED LIABILITIES"]
[19,"Accounts Payable ",231,0,0,{"$f":"+D209-E209","v":0}]
[20,"Notes Payable  ",232,0,0,{"$f":"+D210-E210","v":0}]
[21,"Accounts Payable to Associated Companies",233,0,0,{"$f":"+D211-E211","v":0}]
[22,"Notes Payable to Associated Companies",234,0,0,0]
[23,"Customer Deposits ",235,0,0,0]
[24,"Accrued Taxes",236,0,0,0]
[25,"Accrued Interest ",237,0,0,0]
[26,"Accrued Dividends",238,0,0,0]
[27,"Matured Long-Term Debt",239,0,0,0]
[28,"Matured Interest",240,0,0,0]
[29,"Miscellaneous Current and Accrued Liabilities **",241,0,0,0]
[30,"        Total Current & Accrued Liabilities",null,{"$f":"SUM(D209:D219)","v":0},{"$f":"SUM(E209:E219)","v":0},{"$f":"SUM(F209:F219)","v":0}]
[31]
[32,"DEFERRED CREDITS"]
[33,"Unamortized Premium on Debt",251,0,0,{"$f":"+D223-E223","v":0}]
[34,"Advances for Construction ",252,0,0,{"$f":"+D224-E224","v":0}]
[35,"Other Deferred Credits ",253,0,0,{"$f":"+D225-E225","v":0}]
[36,"Accumulated Deferred Investment Tax Credits",255,0,0,{"$f":"+D226-E226","v":0}]
[37,"         Total Deferred Credits",null,{"$f":"SUM(D223:D226)","v":0},{"$f":"SUM(E223:E226)","v":0},{"$f":"SUM(F223:F226)","v":0}]
[38]
[39,"OPERATING RESERVES"]
[40,"Property Insurance Reserve",261,0,0,{"$f":"+D230-E230","v":0}]
[41,"Injuries and Damages Reserve",262,0,0,{"$f":"+D231-E231","v":0}]
[42,"Pensions and Benefits Reserve",263,0,0,{"$f":"+D232-E232","v":0}]
[43,"Miscellaneous Operating Reserves **",265,0,0,{"$f":"+D233-E233","v":0}]
[44,"       Total Operating Reserves",null,{"$f":"SUM(D230:D233)","v":0},{"$f":"SUM(E230:E233)","v":0},{"$f":"SUM(F230:F233)","v":0}]
[45]
[46,"CONTRIBUTIONS IN AID OF CONSTRUCTION"]
[47,"Contributions in Aid of Construction ",271,{"$f":"D302","v":0},{"$f":"D298","v":0},{"$f":"+D237-E237","v":0}]
[48,"Less:  Amortization of Contributions in Aid of Constr.  ",272,{"$f":"-E302","v":0},{"$f":"-E298","v":0},{"$f":"+D238-E238","v":0}]
[49,"       Net Contributions in Aid of Construction",null,{"$f":"SUM(D237:D238)","v":0},{"$f":"SUM(E237:E238)","v":0},{"$f":"SUM(F237:F238)","v":0}]
[50]
[51,"ACCUMULATED DEFERRED INCOME TAXES"]
[52,"Accum. Def. Income Taxes - Accelerated Amortization",281,0,0,{"$f":"+D242-E242","v":0}]
[53,"Accum. Def. Income Taxes - Liberalized Depreciation",282,0,0,{"$f":"+D243-E243","v":0}]
[54,"Accum. Def. Income Taxes - Other",283,0,0,{"$f":"+D244-E244","v":0}]
[55,"       Total Accum. Deferred Income Taxes",null,{"$f":"SUM(D242:D244)","v":0},{"$f":"SUM(E242:E244)","v":0},{"$f":"SUM(F242:F244)","v":0}]
[56,"       Total Liabilities and Other Credits   (to Page 8, Line 9)",null,{"$f":"+D200+D206+D220+D227+D234+D239+D245","v":0},{"$f":"+E200+E206+E220+E227+E234+E239+E245","v":0},{"$f":"+F200+F206+F220+F227+F234+F239+F245","v":0}]
[null,"* Amount should be entered as NEGATIVE.","** If over $10,000, attach detailed supporting schedule."]
["Docket No. 20-01003\nWater - Class A or B",null,"Page 7 of 11",null,"Revised January 2020"]
[{"$f":"CONCATENATE(\"Annual Report of:    \",'Cover Pages 1-2'!E12)","v":"Annual Report of:    "},null,null,null,null,{"$f":"CONCATENATE(\"For the Period Ending:    December 31, \",'Cover Pages 1-2'!H21)","v":"For the Period Ending:    December 31, 2019"}]
[]
["OTHER INFORMATION"]
[]
["DEPRECIATION RATES BY MAJOR PLANT CATEGORY"]
["Line\nNo.","(a)",null,"(b)","(c)","(d)"]
[null,null,null,null,null,"Weighted Ave."]
[null,null,null,"Total Utility Plant","Annual Depr.  Exp.","Annual Depr. %"]
[1,"Intangible plant                                    (Plant Accts. 301 - 303)",null,0,0,{"$f":"IF(+E257=0,0,E257/D257)","v":0}]
[{"$f":"1+A257","v":2},"Source of Supply plant                        (Plant Accts. 304 - 309)",null,0,0,0]
[3,"Pumping plant                                      (Plant Accts. 310 - 311)",null,0,0,0]
[4,"Water Treatment plant                         (Plant Accts. 320)",null,0,0,0]
[5,"Transmission & Distribution plant      (Plant Accts. 330 - 339)",null,0,0,0]
[6,"General plant                                        (Plant Accts. 340 - 348)",null,0,0,0]
[7,"           Totals ",null,{"$f":"SUM(D257:D262)","v":0},{"$f":"IF(SUM(E257:E262)=E180,E180,\"      ERROR\")","v":0}]
[null,"           Error [Difference from Page 6, Line 1, Col. (b)]",null,{"$f":"D128-D263","v":0}]
[null,"           Error [Difference from Page 5, Line 4a, Col. (b)]",null,null,{"$f":"D70-E263","v":0}]
[]
[]
["VERIFICATION THAT ASSETS EQUALS LIABILITIES ON BALANCE SHEET"]
[null,"(a)",null,"(b)","(c)","(d)"]
[null,null,null,"This Year                    $","Last Year                   $","Increase or (Decrease)"]
[{"$f":"1+A263","v":8},"BALANCE SHEET - Total Assets                      (from Page 6, Line 46)",null,{"$f":"+D173","v":0},{"$f":"+E173","v":0},{"$f":"D271-E271","v":0}]
[{"$f":"1+A271","v":9},"BALANCE SHEET - Total Liabilities                (from Page 7, Line 56)",null,{"$f":"D246","v":0},{"$f":"E246","v":0},{"$f":"D272-E272","v":0}]
[{"$f":"1+A272","v":10},"   Difference -  MUST BE EQUAL TO ZERO!",null,{"$f":"IF(ROUND(D271,0)-ROUND(D272,0)=0,\"0\",\"ERROR\")","v":"0"},{"$f":"IF(ROUND(E271,0)-ROUND(E272,0)=0,\"0\",\"ERROR\")","v":"0"},{"$f":"IF(ROUND(F271,0)-ROUND(F272,0)=0,\"0\",\"ERROR\")","v":"0"}]
[]
[]
[]
["SIMPLIFIED, UNAUDITED AND UNADJUSTED RATE OF RETURN CALCULATION"]
[null,"(a)",null,"(b)","(c)","(d)"]
[null,null,null,"This Year                    $","Last Year                   $","Increase or (Decrease)"]
[{"$f":"1+A273","v":11},"Net Operating Income                                      (from Page 5, Line 16)  ",null,{"$f":"+D83","v":0},{"$f":"+E83","v":0},{"$f":"+D280-E280","v":0}]
[{"$f":"1+A280","v":12},"Rate Base ***",null,{"$f":"+D291","v":0},{"$f":"+E291","v":0},{"$f":"+D281-E281","v":0}]
[{"$f":"1+A281","v":13},"Rate of Return Calculation                               (Line 11 / Line 12)",null,{"$f":"IF(D280=0,0,+D280/D281)","v":0},{"$f":"IF(E280=0,0,+E280/E281)","v":0}]
[{"$f":"1+A282","v":14}]
[15,"*** Rate Base composed of the following:"]
[16,"     Total Utility Plant                                              (Page 6, Line 10)",null,{"$f":"+D137","v":0},{"$f":"+E137","v":0}]
[17,"     Less:  Net CIAC                                                (Page 7, Line 49) ",null,{"$f":"-D239","v":0},{"$f":"-E239","v":0}]
[18,"     Add:  Plant Material and Supplies                    (Page 6, Line 33)",null,{"$f":"+D160","v":0},{"$f":"+E160","v":0}]
[19,"     Add:  Prepayments                                            (Page 6, Line 34)",null,{"$f":"+D161","v":0},{"$f":"+E161","v":0}]
[20,"     Add:  Accum. Def. Inc. Taxes - Acct. 190        (Page 6, Line 43)",null,{"$f":"+D170","v":0},{"$f":"+E170","v":0}]
[21,"     Less:  Accum. Def. Inc. Taxes - Accts. 281/282/283   (Page 7, Line 55)",null,{"$f":"-D245","v":0},{"$f":"-E245","v":0}]
[{"$f":"1+A290","v":22},"                        TOTAL",null,{"$f":"SUM(D285:D290)","v":0},{"$f":"SUM(E285:E290)","v":0}]
[]
[]
[]
[null,"(a)",null,"(b)","(c)","(d)"]
[{"$f":"A291+1","v":23},"WATER UTILITY CIAC",null,"Total Utility CIAC","Accum. Amort.","Net"]
[{"$f":"1+A296","v":24},"CONTRIBUTIONS IN AID OF CONSTRUCTION",null,"(Acct. 271)","(Acct. 272)","Utility CIAC"]
[25,"Balance Beginning of Year",null,0,0,{"$f":"+D298-E298","v":0}]
[26,"Additions:                                            (CIAC added during the year)",null,0,null,{"$f":"+D299","v":0}]
[27,"Current Yr's Amortization on CIAC   (from Page 5, Line 4b)",null,null,{"$f":"-D71","v":0},{"$f":"-E300","v":0}]
[28,"Retirements / Deletions: - CR. *         (CIAC removed during the year)",null,0,0,{"$f":"+D301-E301","v":0}]
[29,"Balance End of Current Year",null,{"$f":"+D298+D299+D301","v":0},{"$f":"+E298+E300+E301","v":0},{"$f":"+D302-E302","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Docket No. 20-01003\nWater - Class A or B",null,"Page 8 of 11",null,"Revised January 2020"]
[{"$f":"CONCATENATE(\"Annual Report of:    \",'Cover Pages 1-2'!E12)","v":"Annual Report of:    "},null,null,null,null,{"$f":"CONCATENATE(\"For the Period Ending:    December 31, \",'Cover Pages 1-2'!H21)","v":"For the Period Ending:    December 31, 2019"}]
[]
[]
["OATH"]
[]
[]
[null,"I,",null,null,null,"on behalf of",", President and"]
[null,null,"[name of signatory]"]
[null,null,null,null,null,"declare under","of"]
[null,"[regulated entity]"]
[null,"penalty of perjury under the laws of the State of Nevada that I have carefully examined the foregoing information"]
[]
[null,"provided to the Public Utilities Commission of Nevada, and declare it to be a complete and correct statement to the"]
[]
[null,"best of my knowledge, information and belief; and that I have the authority to make these representations and to bind"]
[]
[null,"the regulated entity on whose behalf I am providing this information.  I further declare that the foregoing information has"]
[]
[null,"been prepared by me or under my direction from the original books, papers and records of the regulated entity and"]
[]
[null,"and that any accounts and/or figures provided embrace all the relevant financial operations of the regulated entity"]
[]
[null,"during the period of time for which the information is provided."]
[]
[]
[]
[null,null,"Printed Name:"]
[]
[null,null,"Title:"]
[]
[null,null,"Date:"]
[]
[]
[]
[]
[null,null,"Signature:"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Docket No. 20-01003\nWater - Class A or B",null,"Page 9 of 11",null,"Revised January 2020"]

{"sheet":"Report Page 5-A","index":4,"n_rows":36,"n_cols":9,"rows_kept":36,"cut":false,"hidden":false,"merged":[[2,0,2,8]]}
[{"$f":"CONCATENATE(\"Annual Report of:    \",'Cover Pages 1-2'!E12)","v":"Annual Report of:    "},null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"For the Period Ending:    December 31, \",'Cover Pages 1-2'!H21)","v":"For the Period Ending:    December 31, 2019"}]
[]
["WATER OPERATING EXPENSES"]
[null,"(a)",null,"(b)","(c)","(d)","(e)","(f)","(g)"]
["Line  No.","Descriptions","NARUC Water Account Number","SOURCE OF SUPPLY Expenses   OPER. & MAINT.","WATER TREATMENT Expenses   OPER. & MAINT.","TRANSM. & DISTRIBUTION Expenses   OPER. & MAINT.","CUSTOMER ACCOUNTS  Expenses","ADMINS. & GENERAL Expenses","TOTAL"]
[null,"WATER OPERATING EXPENSES",401,"6xx.1 & .2","6xx.3 & .4","6xx.5 & .6","6xx.7","6xx.8"]
[1,"Salaries and Wages - Employees",601,0,0,0,0,0,{"$f":"SUM(D7:H7)","v":0}]
[{"$f":"1+A7","v":2},"Salaries and Wages - Officers, Directors",603,0,0,0,0,0,{"$f":"SUM(D8:H8)","v":0}]
[{"$f":"1+A8","v":3},"Employee Pensions & Benefits",604,0,0,0,0,0,{"$f":"SUM(D9:H9)","v":0}]
[4,"Purchased Water",610,0,0,0,0,0,0]
[5,"Purchased Power",615,0,0,0,0,0,0]
[6,"Fuel for Power Production",616,0,0,0,0,0,0]
[7,"Chemicals",618,0,0,0,0,0,0]
[8,"Material and Supplies",620,0,0,0,0,0,0]
[9,"Contractual Services - Engineering",631,0,0,0,0,0,0]
[10,"Contractual Services - Accounting",632,0,0,0,0,0,0]
[11,"Contractual Services - Legal",633,0,0,0,0,0,0]
[12,"Contractual Services - Management Fees",634,0,0,0,0,0,0]
[13,"Contractual Services - Testing",635,0,0,0,0,0,0]
[14,"Contractual Services - Other **",636,0,0,0,0,0,0]
[15,"Rental of Building / Real Property",641,0,0,0,0,0,0]
[16,"Rental of Equipment",642,0,0,0,0,0,0]
[17,"Transportation Expense",650,0,0,0,0,0,0]
[18,"Insurance Exp. - Vehicle",656,0,0,0,0,0,0]
[19,"Insurance Exp. - Liability",657,0,0,0,0,0,0]
[20,"Insurance Exp. - Workman's Compensation",658,0,0,0,0,0,0]
[21,"Insurance Exp. - Other **",659,0,0,0,0,0,0]
[22,"Advertising Expenses",660,0,0,0,0,0,0]
[23,"Regulatory Comm. Exp. - Amort. of Rate Case",666,0,0,0,0,0,0]
[24,"Regulatory Comm. Exp. - Other **",667,0,0,0,0,0,0]
[25,"Water Resource Conservation Expense",668,0,0,0,0,0,0]
[26,"Bad Debt Expense",670,0,0,0,0,0,0]
[27,"Miscellaneous Expense **",675,0,0,0,0,0,0]
[28]
[29,"      Total Operating Expenses  (to Page 2, Line 3)",401,{"$f":"SUM(D7:D33)","v":0},0,0,0,0,0]
[null,"** If over $10,000, attach detailed supporting schedule."]

{"sheet":"SurchargeInformation","index":5,"n_rows":68,"n_cols":8,"rows_kept":68,"cut":false,"hidden":false,"merged":[[67,0,67,6],[2,0,2,6],[3,0,3,6],[27,0,27,6],[28,0,28,6],[56,1,56,3],[57,1,57,3],[58,1,58,3],[59,1,59,3],[60,1,60,3]]}
[{"$f":"CONCATENATE(\"Annual Report of:    \",'Cover Pages 1-2'!E12)","v":"Annual Report of:    "},null,null,null,null,null,null,{"$f":"CONCATENATE(\"For the Period Ending:  December 31, \",'Cover Pages 1-2'!H21)","v":"For the Period Ending:  December 31, 2019"}]
[]
["System Improvement Surcharge"]
["Schedule 1"]
[]
[]
["MONTH","SURCHARGE AMOUNT","X","NO. OF CUSTOMERS","=","TOTAL BILLED","TOTAL COLLECTED"]
[]
["JANUARY",null,null,null,null,{"$f":"B9*D9","v":0}]
["FEBRUARY",null,null,null,null,{"$f":"B10*D10","v":0}]
["MARCH",null,null,null,null,0]
["APRIL",null,null,null,null,0]
["MAY",null,null,null,null,0]
["JUNE",null,null,null,null,0]
["JULY",null,null,null,null,0]
["AUGUST",null,null,null,null,0]
["SEPTEMBER",null,null,null,null,0]
["OCTOBER",null,null,null,null,0]
["NOVEMBER",null,null,null,null,0]
["DECEMBER",null,null,null,null,0]
[]
[null,null,null,null,null,"TOTAL",{"$f":"SUM(G9:G20)","v":0}]
[]
[]
[]
[{"$f":"CONCATENATE(\"Annual Report of:    \",'Cover Pages 1-2'!E12)","v":"Annual Report of:    "},null,null,null,null,null,null,{"$f":"CONCATENATE(\"For the Period Ending:  December 31, \",'Cover Pages 1-2'!H21)","v":"For the Period Ending:  December 31, 2019"}]
[]
["System Improvement Surcharge"]
["Schedule 2"]
[]
["SUMMARY OF SURCHARGE COLLECTION AND EXPENDITURES"]
[]
[null,null,null,"Account Balance from Previous Year"]
["DEPOSITS"]
[]
["DATE","TOTAL COLLECTED (FROM SCH 1)",null,"TOTAL DEPOSITED",null,"DIFFERENCE                   (EXPLANATION REQUIRED)"]
[]
["JANUARY",{"$f":"G9","v":0}]
["FEBRUARY",{"$f":"G10","v":0}]
["MARCH",0]
["APRIL",0]
["MAY",0]
["JUNE",0]
["JULY",0]
["AUGUST",0]
["SEPTEMBER",0]
["OCTOBER",0]
["NOVEMBER",0]
["DECEMBER",0]
[]
[null,"Total for Year",null,{"$f":"SUM(D38:D49)","v":0},null,null,{"$f":"D51","v":0}]
[]
[null,null,null,"Interest Earned This Year"]
[]
["DISBURSEMENTS - Attach additional sheets if necessary."]
[]
["DATE","DESCRIPTION",null,null,null,"TOTAL DISBURSEMENT"]
[]
[]
[]
[]
[null,null,null,"Total for Year",null,{"$f":"SUM(F58:F61)","v":0},{"$f":"-F62","v":0}]
[null,null,null,"Account Service Charge"]
[]
[null,null,null,"End of Year Account Balance",null,null,{"$f":"G33+G51+G53+G62+G63","v":0}]
[]
["INCLUDE BANK STATEMENT ENDING DECEMBER 31st - Please redact (black out) any"]
["confidential information such as bank account number, Social Security Number or Employer Identification Number in the bank statement, or file the information confidentially pursuant to the Commission's procedures in NAC 703.5274."]

{"sheet":"Data","index":6,"n_rows":40,"n_cols":2,"rows_kept":40,"cut":false,"hidden":true,"merged":[]}
[]
[]
[]
[]
[]
[]
[null,"YEAR:"]
[null,"Select Year"]
[null,2004]
[null,2005]
[null,2006]
[null,2007]
[null,2008]
[null,2009]
[null,2010]
[null,2011]
[null,2012]
[null,2013]
[null,2014]
[null,2015]
[null,2016]
[null,2017]
[null,2018]
[null,2019]
[null,2020]
[null,2021]
[null,2022]
[null,2023]
[null,2024]
[null,2025]
[null,2026]
[null,2027]
[null,2028]
[null,2029]
[null,2030]
[null,2031]
[null,2032]
[null,2033]
[null,2034]
[null,2035]